package db;

public class SQL_Schema {

    class Continent {
    	public static final String TABLE_NAME = "continents";
        public static final String ContinentID = "id";
        public static final String ContinentName = "name";

    }
	
    class Countries {

    	public static final String TABLE_NAME = "countries";
        public static final String CountryID = "country_id";
        public static final String ContinnentID = "continent_id";
        public static final String CountryName = "country_name";

        }
    
    class Cities {

    	
    	public static final String TABLE_NAME = "cities";
        public static final String CountryID = "countryID";
        public static final String CityID = "city_id";
        public static final String CityName = "city_name";
        public static final String Lat = "latitude";
        public static final String Lon = "longitude";

        }
    
    
   
    
    class User{
    	public static final String TABLE_NAME = "users";
        public static final String UserID = "user_id";
        public static final String UserNAME = "user_name";
        public static final String Password = "pass";
    }
    
    class user_in_group{
    	public static final String TABLE_NAME = "usersInGroups";
        public static final String UserID = "user_id";
        public static final String GroupID = "group_id";
        public static final String SCORE = "score";
    }
    

    class Groups {
    	public static final String TABLE_NAME = "groups";
        public static final String groupID = "group_id";
        public static final String groupNAME = "group_name";
        public static final String numQuestions = "number_of_questions";
        public static final String countryID = "citiesByCountries";
        public static final String continentID = "citiesByContinent";
        
    }
    
    class Questions{
    	public static final String TABLE_NAME= "questionsLog";
    	public static final String questionID = "question_id";
    	public static final String userID= "user_id";
    	public static final String groupID="group_id";
    	public static final String cityID="city_id";
    	public static final String score="score";
    	public static final String seconds="seconds";
    	public static final String time="time";
    	
    }
    

    
    }

